Analyse Rapide des notes¶
import pandas as pd
from ipywidgets import interact, interactive, fixed, interact_manual, IntSlider
# Standard plotly imports
import chart_studio.plotly as py
import plotly.graph_objs as go
from plotly.offline import iplot, init_notebook_mode
# Using plotly + cufflinks in offline mode
import cufflinks as cf
cf.go_offline(connected=False)
init_notebook_mode(connected=False)
Continus¶
DS 1¶
df=pd.read_csv("Notes_DSC1.csv", encoding="latin-1")
df.describe()
| Note | Exo1 | Exo2 | Exo 3 | |
|---|---|---|---|---|
| count | 28.000000 | 28.000000 | 28.000000 | 28.000000 |
| mean | 12.660714 | 3.401786 | 4.026786 | 5.000000 |
| std | 3.609539 | 1.198648 | 1.774745 | 1.635826 |
| min | 4.500000 | 0.750000 | 0.500000 | 0.750000 |
| 25% | 10.625000 | 3.000000 | 2.937500 | 4.437500 |
| 50% | 13.000000 | 3.875000 | 4.250000 | 5.500000 |
| 75% | 15.250000 | 4.250000 | 5.062500 | 6.062500 |
| max | 18.250000 | 4.750000 | 7.250000 | 7.000000 |
df['Note']=df["Note"]*100/20
df['Exo1'] = df['Exo1']*100/5
df['Exo2'] = df['Exo2']*100/8
df['Exo 3'] = df['Exo 3']*100/7
df["Note"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes",xTitle='Notes sur 100', yTitle='Quantité')
df["Exo1"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes - Exercice 1 - Calculs matriciel",xTitle='Notes sur 100', yTitle='Quantité')
df["Exo2"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes - Exo 2 - Géométrie",xTitle='Notes sur 100', yTitle='Quantité')
df["Exo 3"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes - Exo 3 - Matrices, inversion",xTitle='Notes sur 100', yTitle='Quantité')
DS 2¶
df=pd.read_csv("Notes_DSC2.csv", encoding="latin-1")
df.describe()
| Note | Exo1 | Exo2 | Exo 3 | Exo 4 | |
|---|---|---|---|---|---|
| count | 22.000000 | 22.000000 | 22.000000 | 22.000000 | 22.000000 |
| mean | 9.750000 | 5.034091 | 0.704545 | 2.250000 | 1.625000 |
| std | 2.928717 | 1.188475 | 0.868210 | 0.893095 | 1.475494 |
| min | 3.500000 | 2.250000 | 0.000000 | 0.000000 | 0.000000 |
| 25% | 8.250000 | 4.500000 | 0.000000 | 2.000000 | 0.250000 |
| 50% | 9.375000 | 5.250000 | 0.500000 | 2.375000 | 1.625000 |
| 75% | 11.375000 | 6.000000 | 1.000000 | 3.000000 | 2.000000 |
| max | 16.000000 | 6.500000 | 3.000000 | 3.500000 | 5.000000 |
df['Note']=df["Note"]*100/20
df['Exo1'] = df['Exo1']*100/7
df['Exo2'] = df['Exo2']*100/4
df['Exo 3'] = df['Exo 3']*100/4
df['Exo 4'] = df['Exo 4']*100/5
df["Note"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes",xTitle='Notes sur 100', yTitle='Quantité')
df["Exo1"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes - Exercice 1 - Statistiques",xTitle='Notes sur 100', yTitle='Quantité')
df["Exo2"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes - Exo 2 - Dénombrement et probabilités conditionnelles",xTitle='Notes sur 100', yTitle='Quantité')
df["Exo 3"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes - Exo 3 - Loi binomiale",xTitle='Notes sur 100', yTitle='Quantité')
df["Exo 4"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes - Exo 4 - Loi normale",xTitle='Notes sur 100', yTitle='Quantité')
Alternants¶
DS 1¶
df=pd.read_csv("Notes_DSA1.csv", encoding="latin-1")
df.describe()
| Note | Exo1 | Exo2 | Exo 3 | |
|---|---|---|---|---|
| count | 22.000000 | 22.000000 | 22.000000 | 22.000000 |
| mean | 11.681818 | 2.579545 | 3.625000 | 5.340909 |
| std | 3.132189 | 0.853516 | 1.873611 | 1.493130 |
| min | 6.000000 | 1.000000 | 0.000000 | 1.500000 |
| 25% | 9.562500 | 2.125000 | 2.437500 | 4.312500 |
| 50% | 11.750000 | 2.500000 | 3.750000 | 5.500000 |
| 75% | 13.187500 | 3.187500 | 4.437500 | 6.500000 |
| max | 19.000000 | 4.000000 | 8.000000 | 7.000000 |
df['Note']=df["Note"]*100/20
df['Exo1'] = df['Exo1']*100/5
df['Exo2'] = df['Exo2']*100/8
df['Exo 3'] = df['Exo 3']*100/7
df["Note"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes",xTitle='Notes sur 100', yTitle='Quantité')
df["Exo1"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes - Exercice 1 - Calculs matriciel",xTitle='Notes sur 100', yTitle='Quantité')
df["Exo2"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes - Exo 2 - Géométrie",xTitle='Notes sur 100', yTitle='Quantité')
df["Exo 3"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes - Exo 3 - Matrices, inversion",xTitle='Notes sur 100', yTitle='Quantité')
DS 2¶
df=pd.read_csv("Notes_DSA2.csv", encoding="latin-1")
df.describe()
| Note | Exo1 | Exo2 | Exo 3 | Exo 4 | |
|---|---|---|---|---|---|
| count | 21.000000 | 21.000000 | 21.000000 | 21.000000 | 21.000000 |
| mean | 11.345238 | 5.761905 | 0.654762 | 2.333333 | 2.488095 |
| std | 3.390682 | 0.878479 | 0.808069 | 1.130081 | 1.701977 |
| min | 6.250000 | 3.500000 | 0.000000 | 0.000000 | 0.000000 |
| 25% | 9.000000 | 5.500000 | 0.000000 | 1.750000 | 1.000000 |
| 50% | 11.250000 | 6.000000 | 0.500000 | 2.500000 | 2.000000 |
| 75% | 13.000000 | 6.250000 | 1.000000 | 3.000000 | 4.000000 |
| max | 19.500000 | 7.000000 | 2.750000 | 4.000000 | 5.000000 |
df['Note']=df["Note"]*100/20
df['Exo1'] = df['Exo1']*100/7
df['Exo2'] = df['Exo2']*100/4
df['Exo 3'] = df['Exo 3']*100/4
df['Exo 4'] = df['Exo 4']*100/5
df["Note"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes",xTitle='Notes sur 100', yTitle='Quantité')
df["Exo1"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes - Exercice 1 - Statistiques",xTitle='Notes sur 100', yTitle='Quantité')
df["Exo2"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes - Exo 2 - Dénombrement et proba conditionnelles",xTitle='Notes sur 100', yTitle='Quantité')
df["Exo 3"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes - Exo 3 - Loi binomiale",xTitle='Notes sur 100', yTitle='Quantité')
df["Exo 4"].iplot(kind="histogram", bins=20, theme="white", title="Répartition des notes - Exo 4 - Loi normale",xTitle='Notes sur 100', yTitle='Quantité')